Using Committed Inventory

In the system, three transactions commit inventory:

• opening a work order and specifying the raw material lots to be used
• entering sales orders with lotted-type items or individually-lotted items, and designating the lot from which the inventory is to be taken and leaving the order open or priced, leaving the order unshipped.
• open planned transfers for lotted or individually-lot costed items.

Committed inventory can never be used for any other purpose. completed work orders, shipping orders, and completing planned transfers remove the commitment. Shipped and invoiced sales orders will appear on the inquiry until the item is costed in Cost of Goods Sold. Items will remain on the committed inventory inquiry for all lots on inventory hold until the hold is released and the items are costed.

Both the Regular (unlotted) Inventory and Lotted Inventory options function similarly, with the exception that the Lotted Inventory report will also show the location ID, lot number, and slot of the items if the location is slotted.

Note: Both the Regular and Lotted Inventory inquiries show a "lots" column. Users should not be confused by the lot numbers the system assigns to unlotted products. The system actually generates an internal lot number for ALL products – it is just not used or displayed for non-lotted products. It is used for item valuation purposes only.

1. When you first enter the Committed Inventory inquiry, a Select An Option window will appear with the following choices:

• EXIT – Select Exit to exit the Committed Inventory inquiry and return to the Shipping menu.
• REGULAR INVENTORY – Select REGULAR INVENTORY to view unlotted items.
• LOTTED INVENTORY – Select LOTTED INVENTORY to view lotted items.

2. At the Single Item (Y/N) field, enter Y (Y=yes) for a single item inquiry or enter N (N=no) to generate the inquiry for multiple items.

If a single item inquiry is selected, enter the item group ID. A Select An Item window will display a list of items in the item group specified. Select the appropriate item.

If a multiple item inquiry is selected, enter the item maskA mask is used to conduct a wild card search. Visually a mask is represented by a series of forward slash marks (///), sometimes with a letter, letters, or number(s) preceding it (1/// or AB///). For example, if you enter ////////, this indicates that you want to list all items defined in the system. If you enter in 1//1//1/, this indicates that you want the system to list items that have the digit "1" in those locations. for the items to include for the inquiry. The item code can also be entered directly into the Item field.

3. The following fields are displayed.

• Item – The item code
• Lot – The lot number for regular inventory and individually lot costed items or, the location and warehouse lot number for lotted items.
• Amount – The total on-hand balance for the lot for the item followed by the stocking unit of measure. If the lot is on hold, an asterisk (*) will appear to the left of the amount near the lot number.
• RSVD Amount – The total amount of the lot that is currently committed by an open planned transfer (TRF), sales order, or an work order (WO)
• WO/TRF Order – The work order number, sales order number, or planned transfer number that is committing the lot
• Date – The work order origination date, the sales order shipping date, or the planned transfer open date
• Cust – The customer code (for sales orders only). WO in this field indicates a work order and a TRF indicates a planned transfer.
• RSVD Amount – The amount of this lot committed to the work order, sales order, or planned transfer. It is also followed by the unit of measure. A "$" will appear after the unit of measure on individually lot-costed items to indicate the sales order has been invoiced and posted to receivables and that it is uncosted.

4. Command options will appear, allowing you to print or choose from a set of other print options. If the list is longer than what will fit on one screen, the Next Page and Prior Page command options appear to allow you to view the next page or the prior page of the inquiry.

Use the Available Actions links below for more information.

Security Required : Shipping - Shipping Inquiry